package com.selen.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;

/**
 * @author Selen
 */
@Data
public class EmpExcel implements Serializable {
    @ExcelProperty(value = {"员工数据统计表", "登陆账号"})
    private String username;

    @ExcelProperty(value = {"员工数据统计表", "手机号码"})
    private String phone;

    @ExcelProperty(value = {"员工数据统计表", "微信号码"})
    private String wechat;

    @ExcelProperty(value = {"员工数据统计表", "邮箱地址"})
    private String email;
    @ExcelProperty(value = {"员工数据统计表", "用户性别"})
    private String gender;
    @ExcelProperty(value = {"员工数据统计表", "用户年龄"})
    private String age;
    @ExcelProperty(value = {"员工数据统计表", "籍贯省份"})
    private String province;
    @ExcelProperty(value = {"员工数据统计表", "现居住地"})
    private String address;
    @ExcelProperty(value = {"员工数据统计表", "真实姓名"})
    private String realname;
    @ExcelProperty(value = {"员工数据统计表", "身份证号"})
    private String idcard;
    @ExcelProperty(value = {"员工数据统计表", "所在部门"})
    private String deptTitle;

    
    @ExcelProperty(value = {"员工数据统计表", "首次创建日期"})
    @DateTimeFormat("yyyy/MM/dd HH:mm:ss")
    private LocalDateTime created;

    @ExcelProperty(value = {"员工数据统计表", "最后创建日期"})
    @DateTimeFormat("yyyy/MM/dd HH:mm:ss")
    private LocalDateTime updated;
}
